How to fetch value inside a Nested JSON in Snowflake (based on value present inside the same JSON)